<?
session_start();
if(empty($_SESSION[user]) and empty($_SESSION[pass])) {
	header('location:../loginForm.php');
}


//$login=mysql_query("SELECT * FROM tbusers WHERE userlogin='$namauser' AND passlogin='$passuser'") or die (mysql_error());
//		$row=mysql_fetch_array($login);
//		if($row[userlogin]==$namauser AND $row[passlogin]==$passuser)
	//	{
	//		$carinama=mysql_query("SELECT namalengkap FROM tbusers WHERE userlogin='$namauser'");
	//		$datanama=mysql_fetch_array($carinama);


include "control_member.php";
?>

<HTML>
 <HEAD>
  <TITLE> Layout dengan CSS </TITLE>
  <link href="../style1.css" rel="stylesheet" type="text/css">
  <style type="text/css">
<!--
.style1 {
	font-weight: bold;
	font-style: italic;
}
.style2 {color: #0000FF}
.style3 {color: #FFFFFF}
.style4 {color: #000000}
-->
  </style>
</HEAD>
 <BODY>
	<div id="box_judul">
	<img src="../../image/Haji.jpg" width="1100" height="110"/>  	</div>
	
	
	
	<div id="box_nav_top" class="style3">
	  <MARQUEE align="center" direction="left"  scrollamount="3" width="70%" behavior="alternate">
	  <h2><span class="style1">Welcome Di Ka'bah Tour & Travel </span></h2> 
	  </marquee> 
		
	</div>
	
	<div id="foto"><img src="../../image/haji1.jpg" width="362" height="109"><img src="../../image/haji071207.jpg" width="371" height="109"><img src="../../image/haji2.jpg" width="359" height="109"></div>
		<div id="box_informasi">
		  <table width="187" height="236" border="1">
		<tr>
			<td width="186" height="50" align="center"><a href="../Home.php" class="style4">Home</a></td>
		</tr>
		
		<tr>
			<td width="186" height="50" align="center"><a href="../informasi/syarat_wajib_haji.php" class="style4">syarat wajib haji</a></td>
		</tr>
		
		<tr>
			<td width="186" height="50" align="center"><a href="../informasi/tempat_bersejarah.php" class="style4">tempat bersejarah </a></td>
		</tr>
		
		<tr>
			<td width="186" height="50" align="center"><a href="../informasi/sekilas_haji.php" class="style4">sekilas umroh </a></td>
		</tr>
		
		<tr>
			<td width="186" height="50" align="center"><a href="../informasi/sekilas_umroh.php" class="style4">sekilas haji</a></td>
		</tr>
		
		<tr>
			<td width="186" height="50" align="center"><a href="../informasi/doa_haji_umroh.php" class="style4">do'a ibadah haji dan umroh</a></td>
		</tr>
		
		<tr>
			<td width="186" height="50" align="center"><a href="../informasi/kontak_kami.php"><span class="style4">kontak kami</span></a></td>
		</tr>
		<tr>
			<td width="186" height="50" align="center"><a href="../pendaftaran_haji/frm_pendaftaran_haji.php"><span class="style4">pendaftaran_haji</span></a></td>
		</tr>
		<tr>
			<td width="186" height="50" align="center"><a href="../informasi/syarat_syarat.php"><span class="style4">syarat_syarat</span></a></td>
		</tr>
		<tr>
			<td width="186" height="50" align="center"><a href="form_laporan.php"><span class="style4">grafik pendaftar haji</span></a></td>
		</tr>


		
	  </table>		
		</div>
	<div id="box_login">
	   <table width="181" border="1">
  <tr>
    <td><div align="center">member room 
	  </div></td>
  </tr>
   <tr>
    <td height="97"><div align="center"><a href="../edit profil/form_edit_profil.php".php"> edit_prifile<br></a><a href="../../loginForm.php".php"> log_out</a></br></div></td>
	
  </tr>
</table>	</div>
  	<div id="box_content">
  	  <div align="left"></div>
 
       <?php echo "<script language='javascript' src='fushion/JSClass/FusionCharts.js'></script>";
$kon = mysql_connect("localhost", "root", "");
mysql_select_db("db_rpl");

//path disesuaikan
include("fushion/Code/PHP/Includes/FusionCharts.php");

$xml = "<chart palette='2' useRoundEdges='1' caption='Grafik pendaftaran_haji' showBorder='1' formatNumberScale='0' numberPrefix=''>";


//mencari total pendaftaran bulan januari
$jan = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='1'";
$qjan = mysql_query($jan);
while ($rjan = mysql_fetch_array($qjan))
{
	$tjan = $tjan + $rjan['kode_pos'];
}
$xml .= "<set label='Jan' value='".$tjan."'/>";
//mencari total pendapatan bulan februari
$feb = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='2'";
$qfeb = mysql_query($feb);
while ($rfeb = mysql_fetch_array($qfeb))
{
	$tfeb = $tfeb + $rfeb['kode_pos'];
}
$xml .= "<set label='Feb' value='".$tfeb."'/>";
//mencari total pendaftaran bulan maret
$mar = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='3'";
$qmar = mysql_query($mar);
while ($rmar = mysql_fetch_array($qmar))
{
	$tmar = $tmar + $rmar['kode_pos'];
}
$xml .= "<set label='Mrt' value='".$tmar."'/>";
//mencari total pendapatan bulan april
$ap = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='4'";
$qap = mysql_query($ap);
while ($rap = mysql_fetch_array($qap))
{
	$tap= $tap + $rap['kode_pos'];
}
$xml .= "<set label='Apr' value='".$tap."'/>";
//mencari total pendaftaran bulan mei
$mei = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='5'";
$qmei = mysql_query($mei);
while ($rmei = mysql_fetch_array($qmei))
{
	$tmei = $tmei + $rmei['kode_pos'];
}
$xml .= "<set label='Mei' value='".$tmei."'/>";
//mencari total pendaftaran bulan juni
$jun= "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='6'";
$qjun = mysql_query($jun);
while ($rjun = mysql_fetch_array($qjun))
{
	$tjun = $tjun + $rjun['kode_pos'];
}
$xml .= "<set label='Jun' value='".$tjun."'/>";
//mencari total pendapatan bulan juli
$jul = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='7'";
$qjul = mysql_query($jul);
while ($rjul = mysql_fetch_array($qjul))
{
	$tjul = $tjul + $rjul['kode_pos'];
}
$xml .= "<set label='Jul' value='".$tjul."'/>";
//mencari total pendaftaran bulan agustus
$agt = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='8'";
$qagt = mysql_query($agt);
while ($ragt = mysql_fetch_array($qagt))
{
	$tagt = $tagt + $ragt['kode_pos'];
}
$xml .= "<set label='Agt' value='".$tagt."'/>";
//mencari total pendaftaran bulan sepetember
$sep = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='9'";
$qsep = mysql_query($sep);
while ($rsep = mysql_fetch_array($qsep))
{
	$tsep = $tsep + $rsep['kode_pos'];
}
$xml .= "<set label='Sep' value='".$tsep."'/>";
//mencari total pendaftaran bulan oktober
$okt = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='10'";
$qokt = mysql_query($okt);
while ($rokt = mysql_fetch_array($qokt))
{
	$tokt = $tokt + $rokt['kode_pos'];
}
$xml .= "<set label='Okt' value='".$tokt."'/>";
//mencari total pendaftaran bulan november
$nov = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='11'";
$qnov = mysql_query($nov);
while ($rnov = mysql_fetch_array($qnov))
{
	$tnov = $tnov + $rnov['kode_pos'];
}
$xml .= "<set label='Nov' value='".$tnov."'/>";
//mencari total pendaftaran bulan desember
$des = "SELECT * FROM pendaftaran_haji WHERE paket_pilihan='12'";
$qdes = mysql_query($des);
while ($rdes = mysql_fetch_array($qdes))
{
	$tdes = $tdes + $rdes['kode_pos'];
}
$xml .= "<set label='Des' value='".$tdes."'/>";

$xml .= "</chart>";

//path disesuaikan
echo renderChart("fushion/Charts/Column3D.swf", "", $xml, "Grafik", 550, 550, false, false); ?>
  <p align="center">&nbsp;</p>
  	</div>
	<div id="footer">
	<p align="center" class="teks1 style3">Copyright by: Temi, Imam, Ayu, Hany .</p>
	</div>
	
 </BODY>
</HTML>
